Appendix: Tax determination criteria
The criteria that can trigger the tax determination in sales and purchase documents is listed below. (Extract from Sage X3 release 2020 R4).
|
Field |
Description |
Data Type |
Length |
Dimension |
Internal type |
Local Menu |
|
ACCCOD |
Accounting code |
CAC |
|
1 |
Alphanumeric |
|
|
AGTPCPBPR |
Collection agent |
M |
4 |
1 |
Local menu |
1 |
|
AGTPCPCPY |
Collection agent |
M |
4 |
1 |
Local menu |
1 |
|
AGTSATTAX |
Collection agent |
M |
4 |
1 |
Local menu |
1 |
|
AMTBAS |
Calculated Basis |
MD5 |
|
1 |
Decimal |
|
|
AMTBAS1 |
Calculated Basis |
MD5 |
|
1 |
Decimal |
|
|
AMTBAS2 |
Calculated Basis |
MD5 |
|
1 |
Decimal |
|
|
AMTNOT |
Inv Amt -Tax |
MD1 |
|
1 |
Decimal |
|
|
AMTNOTLIN |
Line Amount -Tax |
MD1 |
|
1 |
Decimal |
|
|
AMTTAX1 |
Tax Amount 1 |
MD1 |
|
1 |
Decimal |
|
|
AMTTAXLIN1 |
Tax Amount 1 |
MD1 |
|
1 |
Decimal |
|
|
BPRNUM |
BP |
BPR |
|
1 |
Alphanumeric |
|
|
CLE |
Key |
A |
3 |
1 |
Alphanumeric |
|
|
CPY |
Company |
CPY |
|
1 |
Alphanumeric |
|
|
CREUSR |
User |
AUS |
|
1 |
Alphanumeric |
|
|
CUR |
Currency |
CUR |
|
1 |
Alphanumeric |
|
|
DAT |
Date |
D |
|
1 |
Date |
|
|
DLKFIL |
|
A |
50 |
1 |
Alphanumeric |
|
|
FCY |
Site |
FCY |
|
1 |
Alphanumeric |
|
|
FLGSATTAX |
Collection agent |
M |
4 |
25 |
Local menu |
1 |
|
GRP |
Group |
AGF |
|
99 |
Alphanumeric |
|
|
ITMREF |
Product |
ITM |
|
1 |
Alphanumeric |
|
|
ITMWEI |
Item Weight |
WEI |
|
1 |
Decimal |
|
|
LEG |
Legislation |
ADI |
|
1 |
Alphanumeric |
|
|
MODULE |
Module |
M |
15 |
1 |
Local menu |
14 |
|
NBGRP |
Number of groups |
C |
4 |
1 |
Short integer |
|
|
PURFCY |
Purchase site |
FCY |
|
1 |
Alphanumeric |
|
|
QTY |
Quantity |
DCB |
9.6 |
1 |
Decimal |
|
|
QTYSTU |
Quantity STK |
DCB |
9.6 |
1 |
Decimal |
|
|
RATRPT |
Reporting Rate |
RCU |
|
1 |
Decimal |
|
|
SALFCY |
Sales Site |
FCY |
|
1 |
Alphanumeric |
|
|
SATFLG |
Flag |
C |
4 |
1 |
Short integer |
|
|
SATISS |
Issue |
SAT |
|
1 |
Alphanumeric |
|
|
SATRCP |
Receipt |
SAT |
|
1 |
Alphanumeric |
|
|
SATTAX |
BP regions |
A |
3 |
25 |
Alphanumeric |
|
|
TCLCOD |
Product Category |
ITG |
|
1 |
Alphanumeric |
|
|
TSICOD |
Statistical Group |
ADI |
|
3 |
Alphanumeric |
|
|
UPDUSR |
User |
AUS |
|
1 |
Alphanumeric |
|
|
VACBPR |
Tax Rule |
TVB |
|
1 |
Alphanumeric |
|
|
VACITM |
Tax Level |
TVI |
|
1 |
Alphanumeric |
|
|
VATTYP |
Tax Type |
M |
15 |
1 |
Local menu |
232 |